Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Highlight, Is Public Domain, Department, Classification
| Link | rowid ▼ | Object Number | Is Highlight | Is Public Domain | Object ID | Department | Object Name | Title | Culture | Period | Dynasty | Reign | Portfolio | Artist Role | Artist Prefix | Artist Display Name | Artist Display Bio | Artist Suffix | Artist Alpha Sort | Artist Nationality | Artist Begin Date | Artist End Date | Object Date | Object Begin Date | Object End Date | Medium | Dimensions | Credit Line | Geography Type | City | State | County | Country | Region | Subregion | Locale | Locus | Excavation | River | Classification | Rights and Reproduction | Link Resource | Metadata Date | Repository |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 221986 | 221986 | 1991.1073.52 | 0 | 0 | 349546 | Drawings and Prints 11 | Book 97 | Palazzi di Roma de Piu Celebri Architetti Disegnati da Pietro Ferrerio Pittore e Architetto | Etcher|Artist|Artist|Artist|Artist|Artist|Draftsman|Artist|Artist|Artist|Artist|Publisher 2388 | Plates in second book drawn and etched by|After|After|After|After|After|Plates in first book drawn (and engraved?) by|After|After|After|After|Published by | Giovanni Battista Falda|Michelangelo Buonarroti|Gian Lorenzo Bernini|Francesco Borromini|Carlo Maderno|Giuliano da Sangallo|Pietro Ferrerio|Donato d'Agnolo Bramante|Guido Mazzoni|Giulio Romano|Bartolomeo Ammanati (Ammannati)|Giovanni Giacomo De Rossi | Italian, Valduggia 1643–1678 Rome|Italian, Caprese 1475–1564 Rome|Italian, Naples 1598–1680 Rome|Italian, Bissone near Lugano 1599–1667 Rome|Italian, 1556–1629|Italian, 1445–1516|Italian, Rome 1600–1654 Rome|Italian, 1444–1515|Italian, Modena ca. 1450–1518 Modena|Italian, Rome 1499?–1546 Mantua|Italian, Settignano near Florence 1511–1592 Florence|Italian, Rome 1627–1691 Rome | Falda, Giovanni Battista|Michelangelo Buonarroti|Bernini, Gian Lorenzo|Borromini, Francesco|Maderno, Carlo|Sangallo, Giuliano da|Ferrerio, Pietro|Bramante, Donato d'Agnolo|Mazzoni, Guido|Giulio Romano|Ammanati, Bartolomeo|Rossi, Giovanni Giacomo De 24311 | Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian 1587 | 1643 |1475 |1598 |1599 |1556 |1445 |1600 |1444 |1445 |1499 |1511 |1627 | 1678 |1564 |1680 |1667 |1629 |1516 |1654 |1515 |1518 |1546 |1592 |1691 | 1655 | 1655 | 1655 | Engraving 7208 | Overall: 14 3/4 x 18 7/8 x 1 9/16 in. (37.5 x 48 x 4 cm) | Rogers Fund, 1908, transferred from the Library (1991.1073.52) | Rome 571 | Books 442 | http://www.metmuseum.org/art/collection/search/349546 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 236637 | 236637 | 49.38bis | 0 | 0 | 364565 | Drawings and Prints 11 | Book 97 | Carlo Magno Festa Teatrale in Occasione della Nascita del Delfino | Author|Designer|Etcher|Etcher|Etcher|Etcher|Etcher|Author|Author|Publisher|Etcher|Designer 3838 | Music written by|Stage design by|Etched by|Etched by|Etched by|Etched by|Etched by|Libretto written by|Intermedes & divertissemeents written by|Published by|Etched by|Borders designed by | Giovanni Batista Costanzi|Niccolo Michetti|Baldassare Gabbuggiani|Filippo Vasconi|Carlo Grandi|Gasparo Massi|Paolo Pilaja|Cardinal Pietro Ottoboni|Giacomo Orti|Antonio de'Rossi|Gasparo Massi|Girolamo Odam | Italian, active 18th century|Italian, died 1759|Italian, born Florence, 1679|Italian, Rome 1687–1730 Rome|Italian, active 1729–67|Italian, 1698–1731|Italian, active 1720–40|Italian, Venice 1667–1740 Rome|Italian, active 18th century|Italian, 1698–1731|active 18th century | , Rome | Costanzi, Giovanni Batista|Michetti, Niccolo|Gabbuggiani, Baldassare|Vasconi, Filippo|Grandi, Carlo|Massi, Gasparo|Pilaja, Paolo|Ottoboni, Pietro, Cardinal|Orti, Giacomo|Rossi, Antonio de'|Massi, Gasparo|Odam, Girolamo 32356 | Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian 1587 | 1700 |1759 |1679 |1687 |1729 |1698 |1720 |1667 |1700 |1698 |0018 | 1800 |1759 |1779 |1730 |1767 |1731 |1740 |1740 |1800 |1731 |0018 | 1729 | 1729 | 1729 | Etching 26137 | Overall: 16 3/4 x 12 1/2 x 1 3/4 in. (42.5 x 31.8 x 4.4 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1949 | Books 442 | http://www.metmuseum.org/art/collection/search/364565 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 411878 | 411878 | PQ4567 .A2 1584 | 1 | 1 | 679465 | The Libraries 20 | Orlando furioso di M. Lodouico Ariosto nuouamente adornato di figure di rame da Girolamo Porro Padouano ; et di altre cose che saranno notate nella sequente facciata | Author|Author|Author|Author|Author|Author|Author|Author|Author|Publisher|Engraver|Author 5156 | Appresso | Alberto Lavezzola|Girolamo Garofolo|Giuseppe Bononome|Luigi Groto|Niccolò Eugenico|Giovanni Battista Pigna|Giovanni Rota|Camillo Camilli|Girolamo Ruscelli (Alessio Piemontese)|Francesco de' Franceschi|Girolamo Porro|Ludovico Ariosto | Italian, active 1584|Italian, active 1584|Italian|Italian, 1541–1585|Italian|Italian, died 1615|Italian, Viterbo 1500–1566 Venice|Italian, active 16th century|Italian, 1520–1604|Italian, Reggio Emilia 1474–1533 Ferrara | Lavezzola, Alberto|Garofolo, Girolamo|Bononome, Giuseppe|Groto, Luigi|Eugenico, Niccolò|Pigna, Giovanni Battista|Rota, Giovanni|Camilli, Camillo|Ruscelli, Girolamo (Alessio Piemontese)|Franceschi Francesco de'|Porro, Girolamo|Ariosto, Ludovico 51971 | Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian|Italian 1587 | 1584 |1584 |1541 |1615 |1500 |1500 |1520 |1474 | 1584 |1584 |1585 |1615 |1566 |1600 |1604 |1533 | 1584 | 1584 | 1584 | 1 volume bound in 2 (40, 654, 34 pages ; 44 leaves), Height: 11 in. (28 cm) | Gift of Jayne Wrightsman, 2009 | | 33 | Venice|Paris 1234 | | 96 | Italy|France 128 | | 259 | http://www.metmuseum.org/art/collection/search/679465 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
CREATE TABLE "MetObjects" (
"Object Number" TEXT,
"Is Highlight" INTEGER,
"Is Public Domain" INTEGER,
"Object ID" INTEGER,
"Department" INTEGER,
"Object Name" INTEGER,
"Title" TEXT,
"Culture" INTEGER,
"Period" REAL,
"Dynasty" INTEGER,
"Reign" INTEGER,
"Portfolio" INTEGER,
"Artist Role" INTEGER,
"Artist Prefix" REAL,
"Artist Display Name" TEXT,
"Artist Display Bio" TEXT,
"Artist Suffix" REAL,
"Artist Alpha Sort" INTEGER,
"Artist Nationality" INTEGER,
"Artist Begin Date" TEXT,
"Artist End Date" TEXT,
"Object Date" TEXT,
"Object Begin Date" INTEGER,
"Object End Date" INTEGER,
"Medium" INTEGER,
"Dimensions" TEXT,
"Credit Line" TEXT,
"Geography Type" INTEGER,
"City" INTEGER,
"State" INTEGER,
"County" INTEGER,
"Country" INTEGER,
"Region" INTEGER,
"Subregion" INTEGER,
"Locale" INTEGER,
"Locus" INTEGER,
"Excavation" INTEGER,
"River" INTEGER,
"Classification" INTEGER,
"Rights and Reproduction" REAL,
"Link Resource" TEXT,
"Metadata Date" TEXT,
"Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
FOREIGN KEY ("Culture") REFERENCES [Culture](id),
FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
FOREIGN KEY ("Reign") REFERENCES [Reign](id),
FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
FOREIGN KEY ("Medium") REFERENCES [Medium](id),
FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
FOREIGN KEY ("City") REFERENCES [City](id),
FOREIGN KEY ("State") REFERENCES [State](id),
FOREIGN KEY ("County") REFERENCES [County](id),
FOREIGN KEY ("Country") REFERENCES [Country](id),
FOREIGN KEY ("Region") REFERENCES [Region](id),
FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
FOREIGN KEY ("Locale") REFERENCES [Locale](id),
FOREIGN KEY ("Locus") REFERENCES [Locus](id),
FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
FOREIGN KEY ("River") REFERENCES [River](id),
FOREIGN KEY ("Classification") REFERENCES [Classification](id),
FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");